/**
 * 
 */
package com.cms.show.mapper;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.cms.pojo.User;

/**
 * @author zhaoyan
 *
 * 2020年1月7日
 */
public interface UserMapper {

	/**
	 * @return
	 */
	@Select("SELECT id,username ,password,nickname,birthday,gender,locked,create_time,update_time,url,score,role "
			+ "FROM cms_user")
	public List<User> list();

	/**
	 * @param uid
	 * @param flag
	 * @return
	 */
	@Update("UPDATE cms_user SET locked = #{flag} WHERE id = #{uid} ")
	public Integer changeStu(@Param("uid")String uid, @Param("flag")String flag);

	

}
